import xlrd

xlsx = xlrd.open_workbook("d:/python/test.xlsx")
table = xlsx.sheet_by_index(0)
norows = table.nrows
for i in range(1,norows):
    #打印学生的成绩
    print(table.row_values(i,1))
    if(table.row_values(i,0))==100:
        print(table.row_values(i,1))
        print(table.row_values(i,2))
        print('-------------------')